/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50720
 Source Host           : 127.0.0.1
 Source Database       : dingshang

 Target Server Type    : MySQL
 Target Server Version : 50720
 File Encoding         : utf-8

 Date: 01/22/2019 15:49:26 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `ds_keyvalue`
-- ----------------------------
DROP TABLE IF EXISTS `ds_keyvalue`;
CREATE TABLE `ds_keyvalue` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pic_url` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pic_title` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pic_href` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `href1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `href2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value_type` int(11) NOT NULL,
  `value_case1` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value_case2` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value_case3` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value_case4` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value_text` text COLLATE utf8mb4_unicode_ci,
  `value_text2` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=144 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
--  Records of `ds_keyvalue`
-- ----------------------------
BEGIN;
INSERT INTO `ds_keyvalue` VALUES ('6', null, null, null, null, null, '3', '再给500万把', null, null, null, '<p>地方大<span style=\"font-weight: bold;\">幅度</span></p><p><span style=\"font-weight: bold;\">地<span style=\"color: rgb(194, 79, 74);\">方大幅</span>度发<span style=\"text-decoration-line: underline;\">腹股沟管</span></span></p><p><img src=\"http://localhost:8082/pic/1537324471616\" style=\"max-width:100%;\"><span style=\"font-weight: bold;\"><span style=\"text-decoration-line: underline;\"><br></span></span></p><p>地方大幅度发</p><p><iframe height=\"498\" width=\"510\" src=\"http://player.youku.com/embed/XMzgyODYyOTYyNA==\" frameborder=\"0\" \'allowfullscreen\'=\"\"></iframe></p><p>dfdfdfdf</p>', null), ('8', null, null, null, null, null, '3', '规范非官方个', null, null, null, '<p>打发打发</p><p>地方司法局来得及发动机来得及发圣诞节福利</p><p>答复就是的九分裤来得及</p><p>剪短发了空间<img src=\"http://localhost:8082/pic/1537332193671\" style=\"max-width: 100%;\"></p><p>的框架疯狂夺金<img src=\"http://localhost:8082/pic/1537332211595\" style=\"max-width: 100%;\"></p>', null), ('10', null, null, null, null, null, '3', '11', null, null, null, '<p>1111电动蝶阀付付付付付付付付付</p>', null), ('12', null, null, null, null, null, '3', 'dfdfsfd', null, null, null, '<p>dfdsfsd</p><p>fdfsdfsfsf</p><p><img src=\"http://localhost:8082/pic/1537332590659\" style=\"max-width:100%;\"><br></p><p><br></p><p><br></p><p>dfdsfsd</p>', null), ('13', 'product_15373325765225', null, null, '12', null, '2', 'dfdfdfdf', '22222', '111', '11', null, null), ('14', null, null, null, null, null, '3', 'eeeeeeeee', null, null, null, '<p>dddd</p><p><img src=\"http://localhost:8082/pic/1537332983678\" style=\"max-width:100%;\"><br></p>', null), ('15', 'product_15373329695810', null, null, '14', null, '2', '44', '5', '53', '4', null, null), ('16', null, null, null, null, null, '3', '', null, null, null, '<p>dddd</p>', null), ('18', null, null, null, null, null, '3', '', null, null, null, '<p>dddd</p>', null), ('20', null, null, null, null, null, '3', '', null, null, null, '<p>dddd</p>', null), ('22', null, null, null, null, null, '3', '', null, null, null, '<p>dddd</p>', null), ('24', null, null, null, null, null, '3', '', null, null, null, '<p>dddd</p>', null), ('26', null, null, null, null, null, '3', '', null, null, null, '<p>dddd</p>', null), ('28', null, null, null, null, null, '3', '', null, null, null, '<p>dddd</p>', null), ('30', null, null, null, null, null, '3', '', null, null, null, '<p>dddd</p>', null), ('32', null, null, null, null, null, '3', '', null, null, null, '<p>dddd</p>', null), ('34', null, null, null, null, null, '3', 'rerere', null, null, null, '<p>ererere</p>', null), ('36', null, null, null, null, null, '3', 'tyyuu', null, null, null, '<p>dfdfdfd</p><p>dfdf</p>', null), ('37', 'product_15373333394123', null, null, '36', null, '2', 'ttttt', '1', '14', '3', null, null), ('39', null, null, null, null, null, '3', '444', null, null, null, '<p>打发打发</p><p>地方的健康</p><p>动静分离惊世毒妃</p><p>发大水了房价开始多了几分</p>', null), ('40', 'product_15373362131522', null, null, '39', null, '5', '别墅111', '222', '233', '33', null, null), ('41', null, null, null, null, null, '3', '433', null, null, null, '<p>rrrr</p><p>rrrrrr</p>', null), ('43', null, null, null, null, null, '3', '4444', null, null, null, '<p>dsfsdf</p><p>dfjslfjlksd&nbsp;</p><p>fjdlsjflk&nbsp;</p><p>dfjldsjf&nbsp;</p>', null), ('44', 'product_15373372847617', null, null, '43', null, '6', '444', 'd', 'dd', 'ee', null, null), ('45', null, null, null, null, null, '3', '66', null, null, null, '<p>ddfdf</p><p>dfdf</p>', null), ('46', 'product_15373376018227', null, null, '45', null, '7', '44', '444', '455', '55', null, null), ('47', null, null, null, null, null, '3', 'd', null, null, null, '<p>dddd</p>', null), ('48', 'product_15373376418434', null, null, '47', null, '7', 'd', 'd', 'd', 'd', null, null), ('49', null, null, null, null, null, '3', '44', null, null, null, '<p>地方大幅度</p>', null), ('50', 'product_15373384609048', null, null, '49', null, '8', '22', '33', '', '', null, null), ('53', 'product_15373729430452', null, null, null, null, '9', 'errr333333', 'rrrrrrrrrr444', '', '', null, null), ('56', 'product_15373744541340', null, null, null, null, '10', 'dfsdfsf', 'dfdf', 'fdfd', '', null, null), ('57', 'product_15373744827194', null, null, null, null, '10', 'dfsdfsf', 'dfdf', 'fdfd', '', null, null), ('58', null, null, null, null, null, '3', '', null, null, null, '<p><br></p>', null), ('59', '', null, null, '58', null, '5', '11', '111', '', '', null, null), ('60', null, null, null, null, null, '3', '', null, null, null, '<p><br></p>', null), ('61', '', null, null, '60', null, '5', '111', '', '', '', null, null), ('62', null, null, null, null, null, '3', '', null, null, null, '<p><br></p>', null), ('63', '', null, null, '62', null, '5', '111', '111', '', '', null, null), ('73', null, null, null, null, null, '14', '18014822013', 'tom', 'uuu', '9000', null, null), ('74', null, null, null, null, null, '14', '18214822013', 'jack', 'uuu', '9000', null, null), ('75', null, null, null, null, null, '14', '18214822014', 'jack2', 'uuu', '9000', null, null), ('76', null, null, null, null, null, '14', '18214822044', 'jack3', 'uuu', '9000', null, null), ('77', null, null, null, null, null, '14', '18214822045', 'jack4', 'uuu', '9000', null, null), ('80', null, null, null, null, null, '15', '111', 'admin', null, null, null, null), ('82', 'product_15476442313590', '李大头', null, null, null, '12', '555', '15', '设计经理', '0', null, null), ('83', 'product_15476442567381', '张大龙', null, null, null, '12', '888', '1', '设计小弟', '1', null, null), ('89', 'product_15476539057475', '赵三罗', null, null, null, '12', '34', '15', '总裁罗', '0', null, null), ('90', 'product_15476539419283', '梅西', null, null, null, '12', '99', '22', '助力中锋', '1', null, null), ('98', null, 'kdjfkjdkjfkd', null, null, null, '11', 'dfdddddddddddd', null, null, '0', '<p><img src=\"http://localhost:8082/pic/1547657853242\" style=\"max-width:100%;\"><img src=\"http://localhost:8082/pic/1547657859753\" style=\"max-width: 100%;\"><img src=\"http://localhost:8082/pic/1547657864932\" style=\"max-width: 100%;\"><img src=\"http://localhost:8082/pic/1547657872993\" style=\"max-width: 100%;\"><br></p>', null), ('99', null, '施工服务', null, null, null, '11', '发地方大幅度发', null, null, '1', '<p><img src=\"http://localhost:8082/pic/1547658868580\" style=\"max-width:100%;\"><img src=\"http://localhost:8082/pic/1547658873716\" style=\"max-width: 100%;\"><img src=\"http://localhost:8082/pic/1547658878351\" style=\"max-width: 100%;\"><img src=\"http://localhost:8082/pic/1547658883040\" style=\"max-width: 100%;\"><br></p>', null), ('100', null, '售后服务', null, null, null, '11', '方法方法付付', null, null, '2', '<p><img src=\"http://localhost:8082/pic/1547659082882\" style=\"max-width:100%;\"><img src=\"http://localhost:8082/pic/1547659087749\" style=\"max-width: 100%;\"><img src=\"http://localhost:8082/pic/1547659092008\" style=\"max-width: 100%;\"><br></p>', null), ('101', 'product_15481395124452', '狗不理1', null, null, null, '12', '11', '15年年年年1年', '设计主管1', '1', '叫对方考虑JDK浪费的反馈打飞机家乐福绝对是开了房间里京东方开始的减肥凉快圣诞节疯狂了坚实的开了房间大连市解放路看电视剧付款了的设计费塑料袋解放路所得积分凉快圣诞节福利塑料袋解放路所得积分凉快圣诞节福利看', null), ('102', 'product_15476602698057', '西门庆', null, null, null, '12', '2', '1', '设计小滴滴滴', '1', null, null), ('103', 'product_15476602956805', '梅西大概', null, null, null, '12', '3', '2', '设计师老大', '1', null, null), ('104', 'product_15476603157356', '小罗的', null, null, null, '12', '4', '3', '最牛的设计师', '1', null, null), ('105', null, '品牌故事', null, null, null, '13', '地方地方大幅度发', null, null, '0', '<p><img src=\"http://localhost:8082/pic/1547660951112\" style=\"max-width:100%;\"><br></p><p><br></p><p>发的所发生的发顺丰进口量</p><p>房间里的减肥了开始交电费</p><p>所得积分老司机反馈了</p><p>是的分解落实到积分</p><p>的分解落实到会计分录</p><p>kdfjlsjfl</p>', null), ('106', null, '企业文化', null, null, null, '13', 'dfdfdf', null, null, '1', '<p><img src=\"http://localhost:8082/pic/1547661340706\" style=\"max-width:100%;\"><br></p><p><br></p><p><br></p><p>fdff</p><p>djflajsldfjalkjfdkdadsjflk</p><p>京东方来得及浪费时间待返利</p><p>对方立刻开始减肥了会计师离开飞机上了贷款纠纷</p><p>所得积分老司机的风口浪尖塑料袋福建省了会计法卡洛斯</p><p><br></p>', null), ('107', null, '合作伙伴', null, null, null, '13', 'fdfd', null, null, '2', '<p>fdsfa计算两点废旧塑料废旧塑料</p><p>到家了飞机上的看法拉进来</p><p><img src=\"http://localhost:8082/pic/1547661376349\" style=\"max-width:100%;\"><br></p>', null), ('108', null, '练习我们', null, null, null, '13', 'dfdfdf', null, null, '3', '<p>dfsdf</p><p>Jdkfjdlkjf</p><p>贷款纠纷卡兰蒂斯解放路涉及到法律开始代驾发牢骚的</p><p>水电费抗裂砂浆颠覆了圣诞节发了多少</p><p><img src=\"http://localhost:8082/pic/1547661398514\" style=\"max-width:100%;\"><br></p>', null), ('109', null, null, null, null, null, '14', null, null, null, null, null, null), ('110', null, null, null, null, null, '14', null, null, null, null, null, null), ('111', null, null, null, null, null, '14', null, null, null, null, null, null), ('112', null, null, null, null, null, '14', null, null, null, null, null, null), ('113', null, null, null, null, null, '14', null, null, null, null, null, null), ('114', null, null, null, null, null, '14', null, null, null, null, null, null), ('115', null, null, null, null, null, '14', null, null, null, null, null, null), ('116', null, null, null, null, null, '14', null, null, null, null, null, null), ('117', null, null, null, null, null, '14', '', 'fdf', 'dfdfdfd', 'fdfdf', null, null), ('118', null, null, null, null, null, '14', '', 'dfdf', 'dfdfd', 'dfdf', null, null), ('119', null, null, null, null, null, '14', '', 'dfdffdfd', 'dfdfd', 'dfdf', null, null), ('120', null, null, null, null, null, '14', '44444444', '3333', '444', '444', null, null), ('121', null, null, null, null, null, '14', 'fdf', 'fdf', 'dfdfdf', 'dfdf', null, null), ('122', null, null, null, null, null, '14', 'dfdfdfdfd', 'dfdfd', 'dfdf', 'dfdfd', null, null), ('123', null, null, null, null, null, '14', 'dfdfdfdfd', 'dfdfd', 'dfdf', 'dfdfd', null, null), ('124', null, null, null, null, null, '14', 'fdfd', 'dfdf', 'dfd', 'fdfdf', null, null), ('125', null, null, null, null, null, '14', 'dfdf', 'dfdf', 'dfdfd', 'dfdf', null, null), ('126', null, null, null, null, null, '14', '18018987654', 'dfd', 'dfd', 'dfdfd', null, null), ('128', null, null, null, null, null, '1', '南京嘻嘻嘻嘻嘻嘻', '南京鼎尚装饰', 'product_15373133045979', '苏a-99999', null, null), ('129', null, null, null, null, null, '14', '11111111111', '11111', '1', '1', null, null), ('134', 'product_15481307900994', '只基金会计会计', null, null, null, '10', '发的发的打发打发', '', '82', '6', '<p>发大幅度</p><p>的说法飞机离开</p><p>所得积分简单来说看风景</p><p><img src=\"http://img.t.sinajs.cn/t4/appstyle/expression/ext/normal/3c/pcmoren_wu_org.png\" alt=\"[污]\" data-w-e=\"1\"><br></p><p><img src=\"http://localhost:8082/pic/1548130813347\" style=\"max-width:100%;\"><img src=\"http://localhost:8082/pic/1548130819919\" style=\"max-width: 100%;\"><br></p>', '李大头'), ('135', 'product_15481310190948', '是范德萨发斯蒂芬斯蒂芬', null, null, null, '10', '对方是否', '', '89', '6', '<p>的孙菲菲</p><p>是非得失</p><p><img src=\"http://localhost:8082/pic/1548131030331\" style=\"max-width:100%;\"><img src=\"http://localhost:8082/pic/1548131034086\" style=\"max-width: 100%;\"><img src=\"http://localhost:8082/pic/1548131037973\" style=\"max-width: 100%;\"><br></p>', '赵三罗'), ('136', 'product_15481310509662', '对方是否佛挡杀佛水电费', null, null, null, '10', '双方都发顺丰', '', '90', '7', '<p><img src=\"http://localhost:8082/pic/1548131061640\" style=\"max-width:100%;\"><img src=\"http://localhost:8082/pic/1548131065194\" style=\"max-width: 100%;\"><img src=\"http://localhost:8082/pic/1548131069157\" style=\"max-width: 100%;\"><br></p>', '梅西'), ('137', 'product_15481310792660', '对方水电费', null, null, null, '10', '辅导费', '', '90', '22', '<p>fdsfsfdsdf</p><p><img src=\"http://localhost:8082/pic/1548131092005\" style=\"max-width:100%;\"><img src=\"http://localhost:8082/pic/1548131096470\" style=\"max-width: 100%;\"><br></p>', '梅西'), ('138', 'product_15481311071878', '对方水电费', null, null, null, '10', '范德萨发顺丰水电费第三方', '', '102', '22', '<p>所发生的发顺丰<img src=\"http://localhost:8082/pic/1548131116112\" style=\"max-width: 100%;\"><img src=\"http://localhost:8082/pic/1548131120133\" style=\"max-width: 100%;\"></p>', '西门庆'), ('139', 'product_15481311731905', '发送到发顺丰', null, null, null, '10', '佛挡杀佛水电费水电费水电费是', '', '104', '6', '<p>爽肤水的份上<img src=\"http://localhost:8082/pic/1548131182255\" style=\"max-width: 100%;\"><img src=\"http://localhost:8082/pic/1548131186043\" style=\"max-width: 100%;\"></p>', '小罗的'), ('140', 'product_15481362442256', 'JDK房间肯德基发快递', null, null, null, '10', '地方大幅度发大水', '', '89', '6', '<p>对方水电费</p><p><img src=\"http://localhost:8082/pic/1548136257547\" style=\"max-width:100%;\"><img src=\"http://localhost:8082/pic/1548136261133\" style=\"max-width: 100%;\"><img src=\"http://localhost:8082/pic/1548136264805\" style=\"max-width: 100%;\"><br></p>', '赵三罗'), ('141', 'product_15481362864906', '发士大夫撒对方是否', null, null, null, '10', '爽肤水的份上发顺丰', '', '104', '6', '<p>防守打法所发生的</p><p><img src=\"http://localhost:8082/pic/1548136296666\" style=\"max-width:100%;\"><img src=\"http://localhost:8082/pic/1548136300334\" style=\"max-width: 100%;\"><img src=\"http://localhost:8082/pic/1548136303994\" style=\"max-width: 100%;\"><br></p>', '小罗的'), ('142', 'product_15481365432291', '考虑考虑考虑考虑12', null, null, null, '10', '法第三方士大夫12', '', '103', '7', '<p>fsfsfdsfsf</p><p><span style=\"font-weight: bold;\">sdfsdfsdfdsf</span></p><p><img src=\"http://localhost:8082/pic/1548142791881\" style=\"max-width:100%;\"><img src=\"http://localhost:8082/pic/1548142795967\" style=\"max-width: 100%;\"><span style=\"font-weight: bold;\"><br></span></p><p>fdfsdfdsfsdf</p><p><span style=\"text-decoration-line: underline;\">sfjsldjfljdsklfjsldkjflk</span></p><p><img src=\"http://localhost:8082/pic/1548142829039\" style=\"max-width:100%;\"><span style=\"text-decoration-line: underline;\"><br></span></p><p><img src=\"http://localhost:8082/pic/1548142836105\" style=\"max-width:100%;\"><br></p>', '梅西大概'), ('143', 'product_15481432101380', '高司令', null, null, null, '12', '89', '12', '副主管设计师', '0', 'dfsfjljlk福克斯将离开房间老司机的弗兰克圣诞节疯狂了坚实的反馈了塑料袋分解落实到会计法抗裂砂浆风口浪尖是代理机房里开始代驾风口浪尖老司机地方看电视累计返利了圣诞节风刀霜剑弗兰克', null);
COMMIT;

-- ----------------------------
--  Table structure for `ds_navigation`
-- ----------------------------
DROP TABLE IF EXISTS `ds_navigation`;
CREATE TABLE `ds_navigation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nav_title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '导航标题',
  `parent_id` int(11) DEFAULT NULL COMMENT '父级导航ID  木有为-1',
  `status` int(11) DEFAULT NULL COMMENT '1-可用 2-不可用',
  `nav_href` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '跳转地址',
  `nav_title_en` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='导航栏信息表';

-- ----------------------------
--  Records of `ds_navigation`
-- ----------------------------
BEGIN;
INSERT INTO `ds_navigation` VALUES ('1', '主页', '-1', '1', '/', 'Home'), ('2', '装修案例', '-1', '1', '/toXiandaisheji.html', 'Decoration case'), ('3', '服务', '-1', '1', '/toShejiFuwu.html', 'Service'), ('4', '设计师', '-1', '1', '/torzShejishi.html', 'Designer'), ('5', '关于我们', '-1', '1', '/toSipaigushi.html', 'About us'), ('6', '现代风格', '2', '1', '/toXiandaisheji.html', 'Modern'), ('7', '新中式风格', '2', '1', '/toXinzhongshifengge.html', 'New Chinese'), ('8', '美式风格', '2', '1', '/toMeishifengge.html', 'American'), ('9', '欧式风格', '2', '1', '/toOushifengge.html', 'European'), ('10', '美学研究', '2', '0', '/meixueyanjiu.html', 'Esthetics'), ('11', '设计服务', '3', '1', '/toShejiFuwu.html', 'Design'), ('12', '施工服务', '3', '1', '/toShigongfuwu.html', 'construction'), ('13', '售后服务', '3', '1', '/toShouhoufuwu.html', 'After sale'), ('14', '软装设计师', '4', '1', '/torzShejishi.html', 'Soft loading'), ('15', '主创设计师', '4', '1', '/tozcShejishi.html', 'leading creator'), ('16', '鼎尚会客', '4', '0', '/dingshanghuike.html', 'Visitor'), ('17', '品牌故事', '5', '1', '/toSipaigushi.html', 'Brand'), ('18', '企业文化', '5', '1', '/toQiyewenhua.html', 'Culture'), ('19', '合作伙伴', '5', '1', '/toHezuohuoban.html', 'Partner'), ('20', '联系我们', '5', '1', '/toLianxiwomen.html', 'Contact');
COMMIT;

-- ----------------------------
--  Table structure for `ds_picture`
-- ----------------------------
DROP TABLE IF EXISTS `ds_picture`;
CREATE TABLE `ds_picture` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pic_url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '图片地址',
  `pic_href` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '图片跳转链接',
  `pic_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '图片标题',
  `pic_desc` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '图片描述',
  `pic_type` int(11) NOT NULL COMMENT '图片类型 1-首页banner',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='图片信息表';

-- ----------------------------
--  Records of `ds_picture`
-- ----------------------------
BEGIN;
INSERT INTO `ds_picture` VALUES ('7', 'product_15373715508678', null, 'frrr', 'rrr', '1'), ('8', 'product_15373715626910', null, 'rrf', 'fff', '1'), ('9', 'product_15373715706426', null, 'rrrr', 'fffff', '1');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
